-- UAP报表脚本(数量:  1张 生成时间:2019年8月23日 16:31)
--  1.单据对照表( 1个视图,项目号U8CUSTDEF)

-- "单据对照表"
-- 添加新的UAP报表
-- 插入项目信息
DELETE FROM uap_projects WHERE cProjectNum=N'U8CUSTDEF' 
INSERT INTO uap_projects(cProjectId,cProjectName,cProjectDescription,cCreater,cSub_Products,bOpened,dLastDate,bShared,iSharedType,dCreateDate,cProjectNum,iOrder)VALUES(N'65b883c7-3d78-4f16-ba03-326a852ac7c2',N'客户化',N'U8 UAP 客户化项目',N'demo',N'SA,',N'1',N'2019/8/21 18:57:15',N'0',N'0',N'2006/10/24 14:11:29',N'U8CUSTDEF',N'1')
GO

-- UAP报表数据报表级基础信息
DELETE FROM UAP_Report WHERE ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9' 
INSERT INTO UAP_Report(ID,FilterID,DataSourceID,FunctionName,Description,ProjectID,SubID,ClassName,FilterClass,bVB,bSystem,Creator,CreatedTime,bPublished,HelpFileName,HelpIndex,HelpKeyWord,bHadUpgradedFrom861,MappingMenuId,RootReportId,CanSaveAs,DataSourceIdExtended,bUsingReport4MenuId,IsNeedBak)VALUES(N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9',N'3EA74B43-73FB-451D-8897-47EA00FC5977',N'b0465d91-8178-40df-812d-c3d79a66aa1e',N'Function1',N'',N'U8CUSTDEF',N'SA',N'',N'',N'1',N'0',N'demo',N'2019/8/23 16:19:55',N'0',NULL,NULL,NULL,N'1',N'SARPT232635',NULL,N'1',NULL,N'1',NULL)
GO

DELETE FROM UAP_Report_Lang WHERE ReportID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9' AND LocaleID=N'en-US' 
INSERT INTO UAP_Report_Lang(ReportID,LocaleID,Name,Description,NeedExpand)VALUES(N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9',N'en-US',N'单据对照表',NULL,N'0')
DELETE FROM UAP_Report_Lang WHERE ReportID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9' AND LocaleID=N'zh-CN' 
INSERT INTO UAP_Report_Lang(ReportID,LocaleID,Name,Description,NeedExpand)VALUES(N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9',N'zh-CN',N'单据对照表',NULL,N'0')
DELETE FROM UAP_Report_Lang WHERE ReportID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9' AND LocaleID=N'zh-TW' 
INSERT INTO UAP_Report_Lang(ReportID,LocaleID,Name,Description,NeedExpand)VALUES(N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9',N'zh-TW',N'单据对照表',NULL,N'0')
GO

DELETE FROM UAP_ReportUserView WHERE ReportID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9' 
INSERT INTO UAP_ReportUserView(UserID,ReportID,ViewID)VALUES(N'demo',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9',N'f45802d3-ef66-42f6-965c-266d4756396e')
GO

-- UAP报表数据源:可能包含进行扩展后的BO对象
DELETE FROM BD_BusinessObjects WHERE MetaID=N'b0465d91-8178-40df-812d-c3d79a66aa1e' 
INSERT INTO BD_BusinessObjects(MetaID,Name,ProjectNo,SubNo,MetaInfo,Description,Catagory,VoucherType,bCompoundBO)VALUES(N'b0465d91-8178-40df-812d-c3d79a66aa1e',N'vouchermaps(2019-08-23 下午 16:31:37)',N'U8CUSTDEF',N'SA',N'<BusinessObject name="vouchermaps" description="单据对照表" descriptionCN="单据对照表" descriptionTW="" descriptionUS="" entityID="">
<Function type="Query" name="Function1" description="" descriptionCN="" descriptionTW="" descriptionUS="">
<DataQueries><Query name="Query1" querist="SQLQuerist" description="" descriptionCN="" descriptionTW="" descriptionUS="">
<Distinct value="False"/><ResultTable name="ResultTable1" description="" descriptionCN="" descriptionTW="" descriptionUS="" >
<Column name="vouchertype" dataType="String" description="单据类型" descriptionCN="单据类型" descriptionTW="" descriptionUS=""/>
<Column name="ccode" dataType="String" description="原始单号" descriptionCN="原始单号" descriptionTW="" descriptionUS=""/>
<Column name="newcode" dataType="String" description="新单号" descriptionCN="新单号" descriptionTW="" descriptionUS=""/>
<Column name="ddate" dataType="DateTime" description="单据日期" descriptionCN="单据日期" descriptionTW="" descriptionUS=""/>
<Column name="importdate" dataType="DateTime" description="导入日期" descriptionCN="导入日期" descriptionTW="" descriptionUS=""/>
<Column name="processdate" dataType="DateTime" description="处理日期" descriptionCN="处理日期" descriptionTW="" descriptionUS=""/>
<Column name="transtype" dataType="String" description="处理方向" descriptionCN="处理方向" descriptionTW="" descriptionUS=""/>
</ResultTable><Content type="Script" ToolType="Manual"><Select>Select * from wtu..v_datamaps</Select>
<Where></Where>
<OrderBy></OrderBy>
<GroupBy></GroupBy>
<Having></Having>
<From></From>
</Content>
</Query></DataQueries></Function></BusinessObject>',N'单据对照表',N'ReportBO',N'',N'0')
GO

-- UAP报表过滤条件
DELETE FROM flt_DefineMeta_Cust WHERE FilterId=N'3EA74B43-73FB-451D-8897-47EA00FC5977'
DELETE FROM flt_DefineMeta_Cache WHERE FilterId=N'3EA74B43-73FB-451D-8897-47EA00FC5977'

DELETE FROM flt_DefineMeta_Base WHERE FilterID=N'3EA74B43-73FB-451D-8897-47EA00FC5977' 
INSERT INTO flt_DefineMeta_Base(FilterID,ProjectNO,XMLExpression,SubNO,FilterName,FilterDesc,IsUpgrade,bLocked,cLockedBy,PersonItems)VALUES(N'3EA74B43-73FB-451D-8897-47EA00FC5977',N'U8CUSTDEF',N'<root canceladvanceitemlist="" title="" behaviorclass="" hasgroupby="0"><filter><items><item projectno="U8CUSTDEF" position="10" name="importdate" reftype="2" refid="" commonlogic="uq" pointbit="-1" fieldname="importdate" fieldclass="" iscommon="1" mustinput="1" rangeinput="1" multselect="0" allowupdatecomparelogic="1" orlogic="0" showstyle="0" ispara="0" displayinportalview="0" autodisplaytext="0" isfacilitycondition="0" isjoinfulltextquery="0" format=""/></items></filter></root>
',N'SA',NULL,NULL,N'0',NULL,NULL,NULL)
GO

DELETE FROM flt_DefineMeta_Lang WHERE FilterID=N'3EA74B43-73FB-451D-8897-47EA00FC5977' AND LocaleID=N'en-us' 
INSERT INTO flt_DefineMeta_Lang(FilterID,LocaleID,XMLExpression,SubNO,ProjectNO,Title)VALUES(N'3EA74B43-73FB-451D-8897-47EA00FC5977',N'en-us',N'<root><items><item name="importdate"/></items></root>',N'SA',N'U8CUSTDEF',NULL)
DELETE FROM flt_DefineMeta_Lang WHERE FilterID=N'3EA74B43-73FB-451D-8897-47EA00FC5977' AND LocaleID=N'zh-cn' 
INSERT INTO flt_DefineMeta_Lang(FilterID,LocaleID,XMLExpression,SubNO,ProjectNO,Title)VALUES(N'3EA74B43-73FB-451D-8897-47EA00FC5977',N'zh-cn',N'<root><items><item caption="导入日期" columncaption="" enum="" name="importdate"/></items></root>',N'SA',N'U8CUSTDEF',NULL)
DELETE FROM flt_DefineMeta_Lang WHERE FilterID=N'3EA74B43-73FB-451D-8897-47EA00FC5977' AND LocaleID=N'zh-tw' 
INSERT INTO flt_DefineMeta_Lang(FilterID,LocaleID,XMLExpression,SubNO,ProjectNO,Title)VALUES(N'3EA74B43-73FB-451D-8897-47EA00FC5977',N'zh-tw',N'<root><items><item name="importdate"/></items></root>',N'SA',N'U8CUSTDEF',NULL)
GO


-- UAP报表添加新的视图
-- UAP报表视图级基础信息
DELETE FROM UAP_ReportView WHERE ID=N'f45802d3-ef66-42f6-965c-266d4756396e' 
INSERT INTO UAP_ReportView(ID,ReportID,ViewType,Columns,BlandScape,GroupSchemas,PageMargins,PaperType,bSystem,LevelExpend,ViewClass,RowsCount,bShowDetail,PageSetting,Selfaction,PreservedField,CanSaveDefaultFormat,FontColorStyleId,cvieworder,bclassicrptview,reportmergecell)VALUES(N'f45802d3-ef66-42f6-965c-266d4756396e',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9',N'1',NULL,N'0',NULL,N'20,20,20,20',N'6',N'0',NULL,NULL,N'40',N'0',NULL,NULL,NULL,N'0',NULL,N'0',N'0',N'0')
GO

DELETE FROM UAP_ReportView_Lang WHERE ViewID=N'f45802d3-ef66-42f6-965c-266d4756396e' AND LocaleID=N'en-US' 
INSERT INTO UAP_ReportView_Lang(ViewID,LocaleID,Name,bSavedDirectly)VALUES(N'f45802d3-ef66-42f6-965c-266d4756396e',N'en-US',N'单据对照表',NULL)
DELETE FROM UAP_ReportView_Lang WHERE ViewID=N'f45802d3-ef66-42f6-965c-266d4756396e' AND LocaleID=N'zh-CN' 
INSERT INTO UAP_ReportView_Lang(ViewID,LocaleID,Name,bSavedDirectly)VALUES(N'f45802d3-ef66-42f6-965c-266d4756396e',N'zh-CN',N'单据对照表',NULL)
DELETE FROM UAP_ReportView_Lang WHERE ViewID=N'f45802d3-ef66-42f6-965c-266d4756396e' AND LocaleID=N'zh-TW' 
INSERT INTO UAP_ReportView_Lang(ViewID,LocaleID,Name,bSavedDirectly)VALUES(N'f45802d3-ef66-42f6-965c-266d4756396e',N'zh-TW',N'单据对照表',NULL)
GO


-- UAP报表视图的格式信息
UPDATE UAP_ReportView SET ID=N'f45802d3-ef66-42f6-965c-266d4756396e',Format=NULL,RuntimeFormat=N'<RuntimeFormat Id=""><RuntimeFormatGroupFormat Id="00000000-0000-0000-0000-000000000001"><RuntimeFormatGroupStyle IsFoldRow="False" Id="Plane.WithDetail"><RuntimeFormatGroupLevel Id="1"><RuntimeFormatGridColumn Width="92" TextHAlign="1" IsVisible="True" Position="0" IsMerge="False" Id="vouchertype" /><RuntimeFormatGridColumn Width="92" TextHAlign="1" IsVisible="True" Position="1" IsMerge="False" Id="ccode" /><RuntimeFormatGridColumn Width="92" TextHAlign="1" IsVisible="True" Position="2" IsMerge="False" Id="newcode" /><RuntimeFormatGridColumn Width="92" TextHAlign="1" IsVisible="True" Position="3" IsMerge="False" Id="ddate" /><RuntimeFormatGridColumn Width="92" TextHAlign="1" IsVisible="True" Position="4" IsMerge="False" Id="importdate" /><RuntimeFormatGridColumn Width="92" TextHAlign="1" IsVisible="True" Position="5" IsMerge="False" Id="processdate" /><RuntimeFormatGridColumn Width="92" TextHAlign="1" IsVisible="True" Position="6" IsMerge="False" Id="transtype" /></RuntimeFormatGroupLevel></RuntimeFormatGroupStyle></RuntimeFormatGroupFormat></RuntimeFormat>',Chartstring=NULL WHERE ID=N'f45802d3-ef66-42f6-965c-266d4756396e' 
GO

UPDATE UAP_ReportView_Lang SET ViewID=N'f45802d3-ef66-42f6-965c-266d4756396e',LocaleID=N'en-US',Format=NULL WHERE ViewID=N'f45802d3-ef66-42f6-965c-266d4756396e' AND LocaleID=N'en-US' 
UPDATE UAP_ReportView_Lang SET ViewID=N'f45802d3-ef66-42f6-965c-266d4756396e',LocaleID=N'zh-CN',Format=NULL WHERE ViewID=N'f45802d3-ef66-42f6-965c-266d4756396e' AND LocaleID=N'zh-CN' 
UPDATE UAP_ReportView_Lang SET ViewID=N'f45802d3-ef66-42f6-965c-266d4756396e',LocaleID=N'zh-TW',Format=NULL WHERE ViewID=N'f45802d3-ef66-42f6-965c-266d4756396e' AND LocaleID=N'zh-TW' 
GO

-- 备份的原始视图格式
-- 颜色字体方案
-- 功能权限
DELETE FROM UAP_ReportView_AuthId WHERE ViewGuid=N'f45802d3-ef66-42f6-965c-266d4756396e' 
INSERT INTO UAP_ReportView_AuthId(ViewGuid,ReportGuid,ReportId,ViewIndex,IsReportApplyAuthControl)VALUES(N'f45802d3-ef66-42f6-965c-266d4756396e',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001',N'_f45802d3-ef66-42f6-965c-266d4756396e',N'1')
GO

-- 视图的字段权限

-- 门户菜单相关
-- 联查功能

-- 报表自定义事件